package com.atung.dao;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.atung.model.MessageRemind;

@Mapper
public interface MessageRemindDAO {

	/**
	 * 获取消息通知
	 * @param openId
	 * @return
	 */
	@Select("select * from message_remind where open_id=#{openId} and is_delect=0 order by creation_time desc")
	List<MessageRemind>selectMessageRemindByOpenId(@Param("openId")String openId);
	
	
	/**
	 * 获取系统消息
	 * @return
	 */
	@Select(" select * from message_remind where message_type=0 and is_delect=0  order by creation_time desc")
	List<MessageRemind>selectMessageRemind();
}
